package com.bcu.calculus.mapper;

import com.bcu.calculus.entity.Send;
import com.bcu.calculus.entity.UserInfo;
import com.bcu.calculus.entity.UserInfoBranch;

import java.util.List;

public interface UserinfoMapper {
    int deleteByPrimaryKey(String userId);

    int insert(UserInfo record);

    int insertSelective(UserInfo record);

    UserInfo selectByPrimaryKey(String userId);

    List<UserInfo> findAllUserInfo();

    int updateByPrimaryKeySelective(UserInfo record);

    int updateByPrimaryKey(UserInfo record);

    List<UserInfo> slectByUserName(String userName);

    List<Integer> getBranchNumber();

    List<UserInfo> selectAvgScoreByUserBranch(String userBranch);

    List<UserInfo> selectPRByUserBranch(String userBranch);

    List<UserInfo> selectAllBranchPR();

    List<UserInfo> selectALLBranchAvgScore();

    List<UserInfo> selectAllPR();

    List<UserInfo> selectAllAV();

    List<UserInfo> showSend(String flistId, String slistId, String tlsitId, String sendSemseterId);

    List<UserInfo> showSendLikeName(String flistId, String slistId, String tlistId, String sendSemseterId, String likeName);

    List<UserInfo> getAllUserScoreThisSemId(Integer semId);
}